"192.168.0.1:sipop" Previous topic Chapter index Next topic

REGISTROSALIDAHQ_BI

 

 

Descriptions

There is no desription for trigger REGISTROSALIDAHQ_BI

 

Definition


CREATE TRIGGER REGISTROSALIDAHQ_BI FOR REGISTROSALIDAHQ ACTIVE
BEFORE INSERT POSITION 0
AS
DECLARE VARIABLE HIJO INTEGER;
BEGIN
  /* Trigger body */
  HIJO = GEN_ID("gen_registrosalidaHQ",1);
  new.id_registro_salidad =HIJO;
  NEW.datetime_insert='NOW';
  IF ( HIJO >9999) THEN
     EXECUTE STATEMENT 'SET GENERATOR "gen_registrosalida" TO 0';
  new.datetime_insert='NOW';
END

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic